Lookup Lists

The addition of Unicode support with Vitalware 3.0 affects other parts of the system than searching. The most notable change is that punctuation and diacritics are now significant in Lookup List values.

When comparing Lookup List entries prior to Vitalware 3.0, punctuation was removed before the entries were processed. Hence a Lookup List entry of Smith (?) was treated the same as an entry for Smith, so only one value (the first one entered in the system) would be stored. Vitalware 3.0 onwards retains punctuation and diacritics when comparing Lookup List values, meaning that the two entries in our example are treated as separate and we end up with two entries in the Lookup List itself.

When working with Lookup List values it is important to recognise that punctuation and diacritics are now taken into account when comparing values: Zoe and Zoë are different Lookup List values. It is important to keep this in mind when using the Lookup Exact Registry entry, for example.

For more details about Lookup Lists:

Lookup Lists Registry entries include:

Lookup Registry entry

Specify permissions for fields with a Lookup List.

Lookup Exact Registry entry

Specify that a value entered into a Lookup List field must match exactly with an existing value in the Lookup List.

Insert Lookup Show Hidden Registry entry

Specify whether Hidden values in a Lookup List are visible to users when in New and Edit modes.

Query Lookup Show Hidden Registry entry

Specify whether Hidden values in a Lookup List are visible to users when in Search (Query) mode.

Auto Fill Registry entry

Enable / disable automated filling of hierarchy fields.